﻿create table dbo.SystemLogs (
   LogId                nvarchar(50)         collate Chinese_PRC_CI_AS not null,
   LogSources           nvarchar(50)         collate Chinese_PRC_CI_AS null,
   LogCategoryId        nvarchar(10)         collate Chinese_PRC_CI_AS null,
   LogCategoryName      nvarchar(50)         collate Chinese_PRC_CI_AS null,
   LogContents          nvarchar(150)        collate Chinese_PRC_CI_AS null,
   LogRemark            nvarchar(50)         collate Chinese_PRC_CI_AS null,
   RecordTime           datetime             null constraint DF_SystemLogs_RecordTime default getdate(),
   constraint PK_SystemLogs primary key (LogId)
         on "PRIMARY"
)
on "PRIMARY"
go

execute sp_addextendedproperty 'MS_Description', 
   '日志ID',
   'user', 'dbo', 'table', 'SystemLogs', 'column', 'LogId'
go

execute sp_addextendedproperty 'MS_Description', 
   '日志来源',
   'user', 'dbo', 'table', 'SystemLogs', 'column', 'LogSources'
go

execute sp_addextendedproperty 'MS_Description', 
   '日志类型ID',
   'user', 'dbo', 'table', 'SystemLogs', 'column', 'LogCategoryId'
go

execute sp_addextendedproperty 'MS_Description', 
   '日志类型名称',
   'user', 'dbo', 'table', 'SystemLogs', 'column', 'LogCategoryName'
go

execute sp_addextendedproperty 'MS_Description', 
   '日志内容',
   'user', 'dbo', 'table', 'SystemLogs', 'column', 'LogContents'
go

execute sp_addextendedproperty 'MS_Description', 
   '日志备注',
   'user', 'dbo', 'table', 'SystemLogs', 'column', 'LogRemark'
go

execute sp_addextendedproperty 'MS_Description', 
   '记录时间',
   'user', 'dbo', 'table', 'SystemLogs', 'column', 'RecordTime'
go